SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

/** Create Stored Procedures **/
CREATE PROCEDURE dbo.[DnnProduct_SC_DISC_DefaultStampConfigAdd]
	@distID varchar(50),
	@name varchar(50),
	@description text,
	@publisherName varchar(50),
	@staticString varchar(150),
	@fontName varchar(50),
	@fontSize float,
	@textRenderingMode tinyint,
	@textColor varchar(6),
	@textStrokeColor varchar(6),
	@strokeWidth float,
	@placeAs int,
	@x varchar(6),
	@y varchar(6),
	@units tinyint,
	@rotate int,
	@opacity tinyint,
	@fontEmbed bit,
	@fontSubset bit,
	@stampType tinyint,
	@textColorSpace tinyint,
	@strokeColorSpace tinyint
AS
BEGIN
	INSERT INTO DISC_DefaultStampConfig
	(
		distID,
		name,
		description,
		publisherName,
		staticString,
		fontName,
		fontSize,
		textRenderingMode,
		textColor,
		textStrokeColor,
		strokeWidth,
		placeAs,
		x,
		y,
		units,
		rotate,
		opacity,
		fontEmbed,
		fontSubset,
		stampType,
		textColorSpace,
		strokeColorSpace
	)
	VALUES
	(
		@distID,
		@name,
		@description,
		@publisherName,
		@staticString,
		@fontName,
		@fontSize,
		@textRenderingMode,
		@textColor,
		@textStrokeColor,
		@strokeWidth,
		@placeAs,
		@x,
		@y,
		@units,
		@rotate,
		@opacity,
		@fontEmbed,
		@fontSubset,
		@stampType,
		@textColorSpace,
		@strokeColorSpace
	)

	SELECT scope_identity()
END
GO
